﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Zor_IDAL;

namespace Zor_DAL
{
    public class AnnualTaxChart_DAL<T> where T : class
    {
        /// <summary>
        /// 获取年度税收统计饼状图数据
        /// </summary>
        /// <returns></returns>
        public static List<T> GetATList()
        {
            var sql = "select Dt_Name,xiaoji from [dbo].[V_AnnualTaxChart]  ";
            return DapperQuery<T>.DoQueryList(sql, null);
        }

        /// <summary>
        /// 获取所有街办的缴税总额
        /// </summary>
        /// <returns></returns>
        public static List<T> getSumAnnualTax()
        {
            var sql = "select Sum(xiaoji) as SumXiaoji from V_AnnualTaxChart";
            return DapperQuery<T>.DoQueryList(sql, null);
        }
    }
}
